<?php
$connect=mysql_connect("localhost","root","")or die(mysql_error()); 
mysql_select_db("my new database")or die(mysql_error());
if($_post['submit'])
{
$firstname = $_post['firstname'];
$secondname = $_post['secondname'];
$password = $_post['password'];
$collage = $_post['collage'];
$universtiy = $_post['universtiy'];
$mail = $_post['mail'];
$country = $_select['country'];
if ($name && $password && $collage && $mail && $universtiy && $mail && $country )
{ 
$check1 = mysql_query("select * from user3='name');
mysql_query("insert into user3 (id,firstname,secondname,password,collage,universtiy,mail,country values('','firstname', 'secondname','password','collage','universtiy','mail','country') ");

} 
else 
{
 echo "pleas enter values";
}
}

?>
